Specifies a range of Date values that falls within the 1st, 2nd, 3rd, or 4th quarter of the current calendar year. The first quarter of the calendar year includes all dates from January 1st through March 31st. The second quarter of the calendar year includes all dates from April 1st through June 30th. The third quarter of the calendar year includes all dates from July 1st through September 30th. The fourth quarter of the calendar year includes all dates from October 1st through December 31st.
The following examples are applicable to Crystal syntax:
If {orders.ORDER DATE} in Calendar1stQtr Then
Returns the Amount if the date falls on any date in the 1st quarter of the calendar year. The following table identifies the first and last dates included in the date range if today equals 04/10/98.
If today = 04/10/98 | {orders.ORDER DATE} | {orders.ORDER AMOUNT} |
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |